CREATE procedure [dbo].[BAEOrderCheckoutUpdate] @OrderCheckoutID as
int,
    @UserID AS varchar(64),
    @Address1 AS varchar(40),
    @Address2 AS varchar(40),
    @Address3 AS varchar(40),
    @City AS varchar(40),
    @State AS varchar(15),
    @PostalCode AS varchar(10),
    @CreditCardType AS varchar(10),
    @CreditCardNumber AS varchar(100),
    @CreditCardExpiration AS varchar(24),
    @CreditCardAuthCode AS varchar(24),
    @CreditCardName AS varchar(40),
    @CreditCardAddress AS varchar(40),
    @CreditCardAddress2 AS varchar(40),
    @CreditCardAddress3 AS varchar(40),
    @CreditCardCity AS varchar(40),
    @CreditCardState AS varchar(15),
    @CreditCardPostalCode AS varchar(10),
    @CreditCardCountry AS varchar(25),
    @ReadyForCheckout AS bit,
    @Country AS varchar(25),
    @ShipMethod AS varchar(10),
    @PurchaseOrder AS varchar(128),
    @Email AS varchar(100),
    @AddressPurpose AS varchar(20),
    @Name AS varchar(70),
    @Issue_Date AS varchar(10),
    @Issue_Number AS varchar(2),
    @MemberType AS varchar(5),
    @BillingCategory AS varchar(60)
AS
    UPDATE OrderCheckout
    SET
    UserID =             @UserID,            
    Address1 =             @Address1,            
    Address2 =             @Address2,                
    Address3 =             @Address3,
    City =                 @City,            
    StateProvince =     @State,            
    PostalCode =         @PostalCode,            
    CreditCardType =     @CreditCardType,    
    CreditCardNumber =     @CreditCardNumber,            
    CreditCardExpiration =     @CreditCardExpiration,            
    CreditCardAuthCode = @CreditCardAuthCode,                
    CreditCardName = @CreditCardName,            
    CreditCardAddress = @CreditCardAddress,            
    CreditCardAddress2 = @CreditCardAddress2,
    CreditCardAddress3 = @CreditCardAddress3,
    CreditCardCity =     @CreditCardCity,
    CreditCardState =     @CreditCardState,    
    CreditCardPostalCode =         @CreditCardPostalCode,            
    CreditCardCountry =     @CreditCardCountry,            
    ReadyForCheckout = @ReadyForCheckout,                
    Country = @Country,            
    ShipMethod = @ShipMethod,
    PurchaseOrder = @PurchaseOrder,
    Email = @Email,
    AddressPurpose = @AddressPurpose,
    ISSUE_DATE = @Issue_Date,
    ISSUE_NUMBER = @Issue_Number,
    BillingCategory = @BillingCategory,
    MemberType = @MemberType,
    [Name] = @Name

    WHERE OrderCheckoutID = @OrderCheckoutID;

GO